CREATE TABLE "C##TEST".employee
(
    emp_no   NUMBER(10) DEFAULT employee_pkey.NEXTVAL primary key,
    emp_name VARCHAR2(50) NULL,
    job      VARCHAR2(50) NULL,
    mgr      NUMBER(10) NULL,
    hiredate TIMESTAMP NULL,
    salary   float NULL,
    bonus    float NULL,
    dept_no  NUMBER(10) NULL,
    CONSTRAINT fk_deptno FOREIGN KEY (dept_no) REFERENCES "C##TEST".department (dept_no)
);